Overview
Brought to you by YData
Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 2121 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 2.0 MiB |
| Average record size in memory | 969.9 B |
Variable types
| Numeric | 6 |
|---|---|
| Text | 6 |
| DateTime | 2 |
| Categorical | 7 |
Country has constant value "United States" | Constant |
Category has constant value "Furniture" | Constant |
Discount is highly overall correlated with Profit | High correlation |
Postal Code is highly overall correlated with Region and 1 other fields | High correlation |
Profit is highly overall correlated with Discount | High correlation |
Region is highly overall correlated with Postal Code and 1 other fields | High correlation |
State is highly overall correlated with Postal Code and 1 other fields | High correlation |
Row ID has unique values | Unique |
Discount has 836 (39.4%) zeros | Zeros |
Profit has 33 (1.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-10-31 21:09:04.182373 |
|---|---|
| Analysis finished | 2025-10-31 21:09:05.942432 |
| Duration | 1.76 second |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
Row ID
Real number (ℝ)
Unique
| Distinct | 2121 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5041.6436 |
| Minimum | 1 |
|---|---|
| Maximum | 9991 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 495 |
| Q1 | 2568 |
| median | 5145 |
| Q3 | 7534 |
| 95-th percentile | 9494 |
| Maximum | 9991 |
| Range | 9990 |
| Interquartile range (IQR) | 4966 |
Descriptive statistics
| Standard deviation | 2885.7403 |
|---|---|
| Coefficient of variation (CV) | 0.57238086 |
| Kurtosis | -1.2027046 |
| Mean | 5041.6436 |
| Median Absolute Deviation (MAD) | 2480 |
| Skewness | -0.030720169 |
| Sum | 10693326 |
| Variance | 8327496.8 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 1 | 1 | < 0.1% |
| 6714 | 1 | < 0.1% |
| 6783 | 1 | < 0.1% |
| 6780 | 1 | < 0.1% |
| 6779 | 1 | < 0.1% |
| 6768 | 1 | < 0.1% |
| 6766 | 1 | < 0.1% |
| 6762 | 1 | < 0.1% |
| 6757 | 1 | < 0.1% |
| 6756 | 1 | < 0.1% |
| Other values (2111) | 2111 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 2 | 1 | |
| 4 | 1 | |
| 6 | 1 | |
| 11 | 1 | |
| 24 | 1 | |
| 25 | 1 | |
| 28 | 1 | |
| 30 | 1 | |
| 37 | 1 |
| Value | Count | Frequency (%) |
| 9991 | 1 | |
| 9990 | 1 | |
| 9981 | 1 | |
| 9965 | 1 | |
| 9963 | 1 | |
| 9956 | 1 | |
| 9948 | 1 | |
| 9939 | 1 | |
| 9938 | 1 | |
| 9932 | 1 |
Order ID
Text
| Distinct | 1764 |
|---|---|
| Distinct (%) | 83.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 130.6 KiB |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
Unique
| Unique | 1469 ? |
|---|---|
| Unique (%) | 69.3% |
Sample
| 1st row | CA-2016-152156 |
|---|---|
| 2nd row | CA-2016-152156 |
| 3rd row | US-2015-108966 |
| 4th row | CA-2014-115812 |
| 5th row | CA-2014-115812 |
| Value | Count | Frequency (%) |
| us-2015-129007 | 4 | 0.2% |
| ca-2016-157749 | 4 | 0.2% |
| ca-2014-145387 | 4 | 0.2% |
| ca-2015-100146 | 4 | 0.2% |
| ca-2017-125451 | 4 | 0.2% |
| ca-2017-100111 | 4 | 0.2% |
| us-2015-138121 | 4 | 0.2% |
| ca-2015-104346 | 4 | 0.2% |
| us-2017-162558 | 4 | 0.2% |
| ca-2017-144491 | 3 | 0.1% |
| Other values (1754) | 2082 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 5421 | |
| - | 4242 | |
| 2 | 3244 | |
| 0 | 3243 | |
| C | 1734 | 5.8% |
| A | 1734 | 5.8% |
| 6 | 1652 | 5.6% |
| 4 | 1606 | 5.4% |
| 5 | 1588 | 5.3% |
| 7 | 1583 | 5.3% |
| Other values (5) | 3647 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 29694 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 5421 | |
| - | 4242 | |
| 2 | 3244 | |
| 0 | 3243 | |
| C | 1734 | 5.8% |
| A | 1734 | 5.8% |
| 6 | 1652 | 5.6% |
| 4 | 1606 | 5.4% |
| 5 | 1588 | 5.3% |
| 7 | 1583 | 5.3% |
| Other values (5) | 3647 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 29694 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 5421 | |
| - | 4242 | |
| 2 | 3244 | |
| 0 | 3243 | |
| C | 1734 | 5.8% |
| A | 1734 | 5.8% |
| 6 | 1652 | 5.6% |
| 4 | 1606 | 5.4% |
| 5 | 1588 | 5.3% |
| 7 | 1583 | 5.3% |
| Other values (5) | 3647 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 29694 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 5421 | |
| - | 4242 | |
| 2 | 3244 | |
| 0 | 3243 | |
| C | 1734 | 5.8% |
| A | 1734 | 5.8% |
| 6 | 1652 | 5.6% |
| 4 | 1606 | 5.4% |
| 5 | 1588 | 5.3% |
| 7 | 1583 | 5.3% |
| Other values (5) | 3647 |
Order Date
Date
| Distinct | 889 |
|---|---|
| Distinct (%) | 41.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| Minimum | 2014-01-06 00:00:00 |
|---|---|
| Maximum | 2017-12-30 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Ship Date
Date
| Distinct | 960 |
|---|---|
| Distinct (%) | 45.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.7 KiB |
| Minimum | 2014-01-10 00:00:00 |
|---|---|
| Maximum | 2018-01-05 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Ship Mode
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
| Standard Class | |
|---|---|
| Second Class | |
| First Class | |
| Same Day | 119 |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 12.798208 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Second Class |
|---|---|
| 2nd row | Second Class |
| 3rd row | Standard Class |
| 4th row | Standard Class |
| 5th row | Standard Class |
Common Values
| Value | Count | Frequency (%) |
| Standard Class | 1248 | |
| Second Class | 427 | 20.1% |
| First Class | 327 | 15.4% |
| Same Day | 119 | 5.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| class | 2002 | |
| standard | 1248 | |
| second | 427 | 10.1% |
| first | 327 | 7.7% |
| same | 119 | 2.8% |
| day | 119 | 2.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 4736 | |
| s | 4331 | |
| d | 2923 | |
| 2121 | ||
| l | 2002 | |
| C | 2002 | |
| S | 1794 | 6.6% |
| n | 1675 | 6.2% |
| r | 1575 | 5.8% |
| t | 1575 | 5.8% |
| Other values (8) | 2411 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27145 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 4736 | |
| s | 4331 | |
| d | 2923 | |
| 2121 | ||
| l | 2002 | |
| C | 2002 | |
| S | 1794 | 6.6% |
| n | 1675 | 6.2% |
| r | 1575 | 5.8% |
| t | 1575 | 5.8% |
| Other values (8) | 2411 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27145 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 4736 | |
| s | 4331 | |
| d | 2923 | |
| 2121 | ||
| l | 2002 | |
| C | 2002 | |
| S | 1794 | 6.6% |
| n | 1675 | 6.2% |
| r | 1575 | 5.8% |
| t | 1575 | 5.8% |
| Other values (8) | 2411 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27145 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 4736 | |
| s | 4331 | |
| d | 2923 | |
| 2121 | ||
| l | 2002 | |
| C | 2002 | |
| S | 1794 | 6.6% |
| n | 1675 | 6.2% |
| r | 1575 | 5.8% |
| t | 1575 | 5.8% |
| Other values (8) | 2411 |
Customer ID
Text
| Distinct | 707 |
|---|---|
| Distinct (%) | 33.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 118.2 KiB |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Unique
| Unique | 160 ? |
|---|---|
| Unique (%) | 7.5% |
Sample
| 1st row | CG-12520 |
|---|---|
| 2nd row | CG-12520 |
| 3rd row | SO-20335 |
| 4th row | BH-11710 |
| 5th row | BH-11710 |
| Value | Count | Frequency (%) |
| sv-20365 | 15 | 0.7% |
| cj-12010 | 9 | 0.4% |
| kl-16555 | 9 | 0.4% |
| je-15745 | 9 | 0.4% |
| lc-16885 | 9 | 0.4% |
| gb-14530 | 8 | 0.4% |
| la-16780 | 8 | 0.4% |
| jd-16150 | 8 | 0.4% |
| sc-20095 | 8 | 0.4% |
| jl-15835 | 8 | 0.4% |
| Other values (697) | 2030 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 2566 | |
| - | 2121 | |
| 0 | 1800 | 10.6% |
| 5 | 1656 | 9.8% |
| 2 | 981 | 5.8% |
| 7 | 646 | 3.8% |
| 8 | 614 | 3.6% |
| 6 | 612 | 3.6% |
| 3 | 585 | 3.4% |
| 9 | 581 | 3.4% |
| Other values (30) | 4806 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 16968 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2566 | |
| - | 2121 | |
| 0 | 1800 | 10.6% |
| 5 | 1656 | 9.8% |
| 2 | 981 | 5.8% |
| 7 | 646 | 3.8% |
| 8 | 614 | 3.6% |
| 6 | 612 | 3.6% |
| 3 | 585 | 3.4% |
| 9 | 581 | 3.4% |
| Other values (30) | 4806 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 16968 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2566 | |
| - | 2121 | |
| 0 | 1800 | 10.6% |
| 5 | 1656 | 9.8% |
| 2 | 981 | 5.8% |
| 7 | 646 | 3.8% |
| 8 | 614 | 3.6% |
| 6 | 612 | 3.6% |
| 3 | 585 | 3.4% |
| 9 | 581 | 3.4% |
| Other values (30) | 4806 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 16968 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 2566 | |
| - | 2121 | |
| 0 | 1800 | 10.6% |
| 5 | 1656 | 9.8% |
| 2 | 981 | 5.8% |
| 7 | 646 | 3.8% |
| 8 | 614 | 3.6% |
| 6 | 612 | 3.6% |
| 3 | 585 | 3.4% |
| 9 | 581 | 3.4% |
| Other values (30) | 4806 |
Customer Name
Text
| Distinct | 707 |
|---|---|
| Distinct (%) | 33.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 129.0 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 18 |
| Mean length | 12.970297 |
| Min length | 7 |
Unique
| Unique | 160 ? |
|---|---|
| Unique (%) | 7.5% |
Sample
| 1st row | Claire Gute |
|---|---|
| 2nd row | Claire Gute |
| 3rd row | Sean O'Donnell |
| 4th row | Brosina Hoffman |
| 5th row | Brosina Hoffman |
| Value | Count | Frequency (%) |
| michael | 26 | 0.6% |
| john | 23 | 0.5% |
| lena | 22 | 0.5% |
| paul | 22 | 0.5% |
| bill | 22 | 0.5% |
| gary | 21 | 0.5% |
| patrick | 21 | 0.5% |
| rick | 20 | 0.5% |
| brian | 20 | 0.5% |
| liz | 20 | 0.5% |
| Other values (844) | 4046 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2589 | 9.4% |
| e | 2565 | 9.3% |
| 2142 | 7.8% | |
| n | 2139 | 7.8% |
| r | 2052 | 7.5% |
| i | 1637 | 6.0% |
| l | 1421 | 5.2% |
| o | 1278 | 4.6% |
| t | 1155 | 4.2% |
| s | 915 | 3.3% |
| Other values (46) | 9617 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27510 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2589 | 9.4% |
| e | 2565 | 9.3% |
| 2142 | 7.8% | |
| n | 2139 | 7.8% |
| r | 2052 | 7.5% |
| i | 1637 | 6.0% |
| l | 1421 | 5.2% |
| o | 1278 | 4.6% |
| t | 1155 | 4.2% |
| s | 915 | 3.3% |
| Other values (46) | 9617 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27510 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2589 | 9.4% |
| e | 2565 | 9.3% |
| 2142 | 7.8% | |
| n | 2139 | 7.8% |
| r | 2052 | 7.5% |
| i | 1637 | 6.0% |
| l | 1421 | 5.2% |
| o | 1278 | 4.6% |
| t | 1155 | 4.2% |
| s | 915 | 3.3% |
| Other values (46) | 9617 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27510 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2589 | 9.4% |
| e | 2565 | 9.3% |
| 2142 | 7.8% | |
| n | 2139 | 7.8% |
| r | 2052 | 7.5% |
| i | 1637 | 6.0% |
| l | 1421 | 5.2% |
| o | 1278 | 4.6% |
| t | 1155 | 4.2% |
| s | 915 | 3.3% |
| Other values (46) | 9617 |
Segment
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.9 KiB |
| Consumer | |
|---|---|
| Corporate | |
| Home Office |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 8.8165959 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Consumer |
|---|---|
| 2nd row | Consumer |
| 3rd row | Consumer |
| 4th row | Consumer |
| 5th row | Consumer |
Common Values
| Value | Count | Frequency (%) |
| Consumer | 1113 | |
| Corporate | 646 | |
| Home Office | 362 | 17.1% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| consumer | 1113 | |
| corporate | 646 | |
| home | 362 | 14.6% |
| office | 362 | 14.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 2767 | |
| e | 2483 | |
| r | 2405 | |
| C | 1759 | |
| m | 1475 | |
| n | 1113 | 6.0% |
| s | 1113 | 6.0% |
| u | 1113 | 6.0% |
| f | 724 | 3.9% |
| t | 646 | 3.5% |
| Other values (7) | 3102 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18700 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 2767 | |
| e | 2483 | |
| r | 2405 | |
| C | 1759 | |
| m | 1475 | |
| n | 1113 | 6.0% |
| s | 1113 | 6.0% |
| u | 1113 | 6.0% |
| f | 724 | 3.9% |
| t | 646 | 3.5% |
| Other values (7) | 3102 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18700 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 2767 | |
| e | 2483 | |
| r | 2405 | |
| C | 1759 | |
| m | 1475 | |
| n | 1113 | 6.0% |
| s | 1113 | 6.0% |
| u | 1113 | 6.0% |
| f | 724 | 3.9% |
| t | 646 | 3.5% |
| Other values (7) | 3102 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18700 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 2767 | |
| e | 2483 | |
| r | 2405 | |
| C | 1759 | |
| m | 1475 | |
| n | 1113 | 6.0% |
| s | 1113 | 6.0% |
| u | 1113 | 6.0% |
| f | 724 | 3.9% |
| t | 646 | 3.5% |
| Other values (7) | 3102 |
Country
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.5 KiB |
| United States |
|---|
Length
| Max length | 13 |
|---|---|
| Median length | 13 |
| Mean length | 13 |
| Min length | 13 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | United States |
|---|---|
| 2nd row | United States |
| 3rd row | United States |
| 4th row | United States |
| 5th row | United States |
Common Values
| Value | Count | Frequency (%) |
| United States | 2121 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| united | 2121 | |
| states | 2121 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 6363 | |
| e | 4242 | |
| U | 2121 | 7.7% |
| n | 2121 | 7.7% |
| i | 2121 | 7.7% |
| d | 2121 | 7.7% |
| 2121 | 7.7% | |
| S | 2121 | 7.7% |
| a | 2121 | 7.7% |
| s | 2121 | 7.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27573 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 6363 | |
| e | 4242 | |
| U | 2121 | 7.7% |
| n | 2121 | 7.7% |
| i | 2121 | 7.7% |
| d | 2121 | 7.7% |
| 2121 | 7.7% | |
| S | 2121 | 7.7% |
| a | 2121 | 7.7% |
| s | 2121 | 7.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27573 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 6363 | |
| e | 4242 | |
| U | 2121 | 7.7% |
| n | 2121 | 7.7% |
| i | 2121 | 7.7% |
| d | 2121 | 7.7% |
| 2121 | 7.7% | |
| S | 2121 | 7.7% |
| a | 2121 | 7.7% |
| s | 2121 | 7.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27573 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 6363 | |
| e | 4242 | |
| U | 2121 | 7.7% |
| n | 2121 | 7.7% |
| i | 2121 | 7.7% |
| d | 2121 | 7.7% |
| 2121 | 7.7% | |
| S | 2121 | 7.7% |
| a | 2121 | 7.7% |
| s | 2121 | 7.7% |
City
Text
| Distinct | 371 |
|---|---|
| Distinct (%) | 17.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 121.0 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 9.3328619 |
| Min length | 4 |
Unique
| Unique | 156 ? |
|---|---|
| Unique (%) | 7.4% |
Sample
| 1st row | Henderson |
|---|---|
| 2nd row | Henderson |
| 3rd row | Fort Lauderdale |
| 4th row | Los Angeles |
| 5th row | Los Angeles |
| Value | Count | Frequency (%) |
| city | 206 | 6.8% |
| new | 196 | 6.5% |
| york | 193 | 6.4% |
| san | 177 | 5.9% |
| los | 154 | 5.1% |
| angeles | 154 | 5.1% |
| philadelphia | 111 | 3.7% |
| francisco | 102 | 3.4% |
| seattle | 97 | 3.2% |
| houston | 81 | 2.7% |
| Other values (400) | 1551 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 1865 | 9.4% |
| a | 1640 | 8.3% |
| o | 1625 | 8.2% |
| i | 1316 | 6.6% |
| n | 1300 | 6.6% |
| l | 1231 | 6.2% |
| s | 1001 | 5.1% |
| r | 988 | 5.0% |
| t | 946 | 4.8% |
| 901 | 4.6% | |
| Other values (40) | 6982 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19795 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 1865 | 9.4% |
| a | 1640 | 8.3% |
| o | 1625 | 8.2% |
| i | 1316 | 6.6% |
| n | 1300 | 6.6% |
| l | 1231 | 6.2% |
| s | 1001 | 5.1% |
| r | 988 | 5.0% |
| t | 946 | 4.8% |
| 901 | 4.6% | |
| Other values (40) | 6982 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19795 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 1865 | 9.4% |
| a | 1640 | 8.3% |
| o | 1625 | 8.2% |
| i | 1316 | 6.6% |
| n | 1300 | 6.6% |
| l | 1231 | 6.2% |
| s | 1001 | 5.1% |
| r | 988 | 5.0% |
| t | 946 | 4.8% |
| 901 | 4.6% | |
| Other values (40) | 6982 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19795 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 1865 | 9.4% |
| a | 1640 | 8.3% |
| o | 1625 | 8.2% |
| i | 1316 | 6.6% |
| n | 1300 | 6.6% |
| l | 1231 | 6.2% |
| s | 1001 | 5.1% |
| r | 988 | 5.0% |
| t | 946 | 4.8% |
| 901 | 4.6% | |
| Other values (40) | 6982 |
State
Categorical
High correlation
| Distinct | 48 |
|---|---|
| Distinct (%) | 2.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.3 KiB |
| California | |
|---|---|
| New York | |
| Texas | |
| Pennsylvania | |
| Illinois | |
| Other values (43) |
Length
| Max length | 20 |
|---|---|
| Median length | 14 |
| Mean length | 8.5318246 |
| Min length | 4 |
Unique
| Unique | 4 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | Kentucky |
|---|---|
| 2nd row | Kentucky |
| 3rd row | Florida |
| 4th row | California |
| 5th row | California |
Common Values
| Value | Count | Frequency (%) |
| California | 444 | |
| New York | 236 | 11.1% |
| Texas | 202 | 9.5% |
| Pennsylvania | 125 | 5.9% |
| Illinois | 123 | 5.8% |
| Washington | 114 | 5.4% |
| Ohio | 93 | 4.4% |
| Florida | 85 | 4.0% |
| Virginia | 52 | 2.5% |
| Colorado | 51 | 2.4% |
| Other values (38) | 596 |
Length
| Value | Count | Frequency (%) |
| california | 444 | |
| new | 272 | 11.0% |
| york | 236 | 9.6% |
| texas | 202 | 8.2% |
| pennsylvania | 125 | 5.1% |
| illinois | 123 | 5.0% |
| washington | 114 | 4.6% |
| ohio | 93 | 3.8% |
| florida | 85 | 3.4% |
| virginia | 53 | 2.1% |
| Other values (43) | 719 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 2269 | |
| i | 2153 | |
| n | 1745 | 9.6% |
| o | 1585 | 8.8% |
| r | 1168 | 6.5% |
| l | 1090 | 6.0% |
| e | 1052 | 5.8% |
| s | 1010 | 5.6% |
| C | 559 | 3.1% |
| f | 447 | 2.5% |
| Other values (36) | 5018 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18096 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 2269 | |
| i | 2153 | |
| n | 1745 | 9.6% |
| o | 1585 | 8.8% |
| r | 1168 | 6.5% |
| l | 1090 | 6.0% |
| e | 1052 | 5.8% |
| s | 1010 | 5.6% |
| C | 559 | 3.1% |
| f | 447 | 2.5% |
| Other values (36) | 5018 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18096 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 2269 | |
| i | 2153 | |
| n | 1745 | 9.6% |
| o | 1585 | 8.8% |
| r | 1168 | 6.5% |
| l | 1090 | 6.0% |
| e | 1052 | 5.8% |
| s | 1010 | 5.6% |
| C | 559 | 3.1% |
| f | 447 | 2.5% |
| Other values (36) | 5018 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18096 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 2269 | |
| i | 2153 | |
| n | 1745 | 9.6% |
| o | 1585 | 8.8% |
| r | 1168 | 6.5% |
| l | 1090 | 6.0% |
| e | 1052 | 5.8% |
| s | 1010 | 5.6% |
| C | 559 | 3.1% |
| f | 447 | 2.5% |
| Other values (36) | 5018 |
Postal Code
Real number (ℝ)
High correlation
| Distinct | 454 |
|---|---|
| Distinct (%) | 21.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 55726.556 |
| Minimum | 1040 |
|---|---|
| Maximum | 99301 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.7 KiB |
Quantile statistics
| Minimum | 1040 |
|---|---|
| 5-th percentile | 10009 |
| Q1 | 22801 |
| median | 60505 |
| Q3 | 90032 |
| 95-th percentile | 98103 |
| Maximum | 99301 |
| Range | 98261 |
| Interquartile range (IQR) | 67231 |
Descriptive statistics
| Standard deviation | 32261.888 |
|---|---|
| Coefficient of variation (CV) | 0.57893203 |
| Kurtosis | -1.4944761 |
| Mean | 55726.556 |
| Median Absolute Deviation (MAD) | 29544 |
| Skewness | -0.16116852 |
| Sum | 1.1819603 × 108 |
| Variance | 1.0408294 × 109 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 10035 | 59 | 2.8% |
| 10024 | 47 | 2.2% |
| 10011 | 44 | 2.1% |
| 10009 | 42 | 2.0% |
| 94122 | 41 | 1.9% |
| 19140 | 39 | 1.8% |
| 94110 | 37 | 1.7% |
| 98103 | 37 | 1.7% |
| 90045 | 34 | 1.6% |
| 98115 | 31 | 1.5% |
| Other values (444) | 1710 |
| Value | Count | Frequency (%) |
| 1040 | 1 | < 0.1% |
| 1752 | 2 | 0.1% |
| 1810 | 1 | < 0.1% |
| 1841 | 7 | |
| 1852 | 3 | 0.1% |
| 2038 | 8 | |
| 2138 | 1 | < 0.1% |
| 2148 | 1 | < 0.1% |
| 2149 | 6 | |
| 2151 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 99301 | 1 | < 0.1% |
| 99207 | 2 | 0.1% |
| 98661 | 2 | 0.1% |
| 98632 | 1 | < 0.1% |
| 98502 | 2 | 0.1% |
| 98226 | 1 | < 0.1% |
| 98198 | 1 | < 0.1% |
| 98115 | 31 | |
| 98105 | 29 | |
| 98103 | 37 |
Region
Categorical
High correlation
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 111.6 KiB |
| West | |
|---|---|
| East | |
| Central | |
| South |
Length
| Max length | 7 |
|---|---|
| Median length | 4 |
| Mean length | 4.8368694 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | South |
|---|---|
| 2nd row | South |
| 3rd row | South |
| 4th row | West |
| 5th row | West |
Common Values
| Value | Count | Frequency (%) |
| West | 707 | |
| East | 601 | |
| Central | 481 | |
| South | 332 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| west | 707 | |
| east | 601 | |
| central | 481 | |
| south | 332 |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 2121 | |
| s | 1308 | |
| e | 1188 | |
| a | 1082 | |
| W | 707 | 6.9% |
| E | 601 | 5.9% |
| C | 481 | 4.7% |
| n | 481 | 4.7% |
| r | 481 | 4.7% |
| l | 481 | 4.7% |
| Other values (4) | 1328 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 10259 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| t | 2121 | |
| s | 1308 | |
| e | 1188 | |
| a | 1082 | |
| W | 707 | 6.9% |
| E | 601 | 5.9% |
| C | 481 | 4.7% |
| n | 481 | 4.7% |
| r | 481 | 4.7% |
| l | 481 | 4.7% |
| Other values (4) | 1328 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 10259 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| t | 2121 | |
| s | 1308 | |
| e | 1188 | |
| a | 1082 | |
| W | 707 | 6.9% |
| E | 601 | 5.9% |
| C | 481 | 4.7% |
| n | 481 | 4.7% |
| r | 481 | 4.7% |
| l | 481 | 4.7% |
| Other values (4) | 1328 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 10259 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| t | 2121 | |
| s | 1308 | |
| e | 1188 | |
| a | 1082 | |
| W | 707 | 6.9% |
| E | 601 | 5.9% |
| C | 481 | 4.7% |
| n | 481 | 4.7% |
| r | 481 | 4.7% |
| l | 481 | 4.7% |
| Other values (4) | 1328 |
Product ID
Text
| Distinct | 375 |
|---|---|
| Distinct (%) | 17.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 132.7 KiB |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | FUR-BO-10001798 |
|---|---|
| 2nd row | FUR-CH-10000454 |
| 3rd row | FUR-TA-10000577 |
| 4th row | FUR-FU-10001487 |
| 5th row | FUR-TA-10001539 |
| Value | Count | Frequency (%) |
| fur-fu-10004270 | 16 | 0.8% |
| fur-ch-10001146 | 15 | 0.7% |
| fur-ch-10002647 | 15 | 0.7% |
| fur-ch-10002880 | 14 | 0.7% |
| fur-fu-10001473 | 14 | 0.7% |
| fur-ch-10003774 | 14 | 0.7% |
| fur-ta-10001095 | 13 | 0.6% |
| fur-fu-10004864 | 13 | 0.6% |
| fur-ch-10004287 | 13 | 0.6% |
| fur-fu-10004848 | 12 | 0.6% |
| Other values (365) | 1982 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7346 | |
| - | 4242 | |
| F | 3078 | |
| 1 | 3078 | |
| U | 3078 | |
| R | 2121 | 6.7% |
| 4 | 1061 | 3.3% |
| 3 | 1009 | 3.2% |
| 2 | 932 | 2.9% |
| 7 | 784 | 2.5% |
| Other values (10) | 5086 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 31815 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7346 | |
| - | 4242 | |
| F | 3078 | |
| 1 | 3078 | |
| U | 3078 | |
| R | 2121 | 6.7% |
| 4 | 1061 | 3.3% |
| 3 | 1009 | 3.2% |
| 2 | 932 | 2.9% |
| 7 | 784 | 2.5% |
| Other values (10) | 5086 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 31815 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7346 | |
| - | 4242 | |
| F | 3078 | |
| 1 | 3078 | |
| U | 3078 | |
| R | 2121 | 6.7% |
| 4 | 1061 | 3.3% |
| 3 | 1009 | 3.2% |
| 2 | 932 | 2.9% |
| 7 | 784 | 2.5% |
| Other values (10) | 5086 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 31815 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 7346 | |
| - | 4242 | |
| F | 3078 | |
| 1 | 3078 | |
| U | 3078 | |
| R | 2121 | 6.7% |
| 4 | 1061 | 3.3% |
| 3 | 1009 | 3.2% |
| 2 | 932 | 2.9% |
| 7 | 784 | 2.5% |
| Other values (10) | 5086 |
Category
Categorical
Constant
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 120.3 KiB |
| Furniture |
|---|
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Furniture |
|---|---|
| 2nd row | Furniture |
| 3rd row | Furniture |
| 4th row | Furniture |
| 5th row | Furniture |
Common Values
| Value | Count | Frequency (%) |
| Furniture | 2121 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| furniture | 2121 |
Most occurring characters
| Value | Count | Frequency (%) |
| u | 4242 | |
| r | 4242 | |
| F | 2121 | |
| n | 2121 | |
| i | 2121 | |
| t | 2121 | |
| e | 2121 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 19089 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| u | 4242 | |
| r | 4242 | |
| F | 2121 | |
| n | 2121 | |
| i | 2121 | |
| t | 2121 | |
| e | 2121 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 19089 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| u | 4242 | |
| r | 4242 | |
| F | 2121 | |
| n | 2121 | |
| i | 2121 | |
| t | 2121 | |
| e | 2121 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 19089 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| u | 4242 | |
| r | 4242 | |
| F | 2121 | |
| n | 2121 | |
| i | 2121 | |
| t | 2121 | |
| e | 2121 |
Sub-Category
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 119.4 KiB |
| Furnishings | |
|---|---|
| Chairs | |
| Tables | |
| Bookcases |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 8.5785007 |
| Min length | 6 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Bookcases |
|---|---|
| 2nd row | Chairs |
| 3rd row | Tables |
| 4th row | Furnishings |
| 5th row | Tables |
Common Values
| Value | Count | Frequency (%) |
| Furnishings | 957 | |
| Chairs | 617 | |
| Tables | 319 | 15.0% |
| Bookcases | 228 | 10.7% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| furnishings | 957 | |
| chairs | 617 | |
| tables | 319 | 15.0% |
| bookcases | 228 | 10.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| s | 3306 | |
| i | 2531 | |
| n | 1914 | |
| r | 1574 | |
| h | 1574 | |
| a | 1164 | 6.4% |
| u | 957 | 5.3% |
| F | 957 | 5.3% |
| g | 957 | 5.3% |
| C | 617 | 3.4% |
| Other values (8) | 2644 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 18195 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| s | 3306 | |
| i | 2531 | |
| n | 1914 | |
| r | 1574 | |
| h | 1574 | |
| a | 1164 | 6.4% |
| u | 957 | 5.3% |
| F | 957 | 5.3% |
| g | 957 | 5.3% |
| C | 617 | 3.4% |
| Other values (8) | 2644 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 18195 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| s | 3306 | |
| i | 2531 | |
| n | 1914 | |
| r | 1574 | |
| h | 1574 | |
| a | 1164 | 6.4% |
| u | 957 | 5.3% |
| F | 957 | 5.3% |
| g | 957 | 5.3% |
| C | 617 | 3.4% |
| Other values (8) | 2644 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 18195 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| s | 3306 | |
| i | 2531 | |
| n | 1914 | |
| r | 1574 | |
| h | 1574 | |
| a | 1164 | 6.4% |
| u | 957 | 5.3% |
| F | 957 | 5.3% |
| g | 957 | 5.3% |
| C | 617 | 3.4% |
| Other values (8) | 2644 |
Product Name
Text
| Distinct | 380 |
|---|---|
| Distinct (%) | 17.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 191.7 KiB |
Length
| Max length | 90 |
|---|---|
| Median length | 70 |
| Mean length | 43.035361 |
| Min length | 15 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | 0.3% |
Sample
| 1st row | Bush Somerset Collection Bookcase |
|---|---|
| 2nd row | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back |
| 3rd row | Bretford CR4500 Series Slim Rectangular Table |
| 4th row | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood |
| 5th row | Chromcraft Rectangular Conference Tables |
| Value | Count | Frequency (%) |
| chair | 479 | 3.6% |
| global | 284 | 2.1% |
| table | 219 | 1.6% |
| hon | 190 | 1.4% |
| eldon | 181 | 1.4% |
| wall | 180 | 1.4% |
| clock | 179 | 1.3% |
| chairs | 174 | 1.3% |
| x | 169 | 1.3% |
| series | 167 | 1.3% |
| Other values (661) | 11053 |
Most occurring characters
| Value | Count | Frequency (%) |
| 11156 | 12.2% | |
| e | 7627 | 8.4% |
| a | 6416 | 7.0% |
| o | 5392 | 5.9% |
| r | 4871 | 5.3% |
| l | 4741 | 5.2% |
| i | 4522 | 5.0% |
| s | 3983 | 4.4% |
| t | 3609 | 4.0% |
| n | 3552 | 3.9% |
| Other values (64) | 35409 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 91278 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 11156 | 12.2% | |
| e | 7627 | 8.4% |
| a | 6416 | 7.0% |
| o | 5392 | 5.9% |
| r | 4871 | 5.3% |
| l | 4741 | 5.2% |
| i | 4522 | 5.0% |
| s | 3983 | 4.4% |
| t | 3609 | 4.0% |
| n | 3552 | 3.9% |
| Other values (64) | 35409 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 91278 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 11156 | 12.2% | |
| e | 7627 | 8.4% |
| a | 6416 | 7.0% |
| o | 5392 | 5.9% |
| r | 4871 | 5.3% |
| l | 4741 | 5.2% |
| i | 4522 | 5.0% |
| s | 3983 | 4.4% |
| t | 3609 | 4.0% |
| n | 3552 | 3.9% |
| Other values (64) | 35409 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 91278 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 11156 | 12.2% | |
| e | 7627 | 8.4% |
| a | 6416 | 7.0% |
| o | 5392 | 5.9% |
| r | 4871 | 5.3% |
| l | 4741 | 5.2% |
| i | 4522 | 5.0% |
| s | 3983 | 4.4% |
| t | 3609 | 4.0% |
| n | 3552 | 3.9% |
| Other values (64) | 35409 |
Sales
Real number (ℝ)
| Distinct | 1636 |
|---|---|
| Distinct (%) | 77.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 349.83489 |
| Minimum | 1.892 |
|---|---|
| Maximum | 4416.174 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.7 KiB |
Quantile statistics
| Minimum | 1.892 |
|---|---|
| 5-th percentile | 10.02 |
| Q1 | 47.04 |
| median | 182.22 |
| Q3 | 435.168 |
| 95-th percentile | 1317.492 |
| Maximum | 4416.174 |
| Range | 4414.282 |
| Interquartile range (IQR) | 388.128 |
Descriptive statistics
| Standard deviation | 503.17914 |
|---|---|
| Coefficient of variation (CV) | 1.4383332 |
| Kurtosis | 15.91681 |
| Mean | 349.83489 |
| Median Absolute Deviation (MAD) | 151.884 |
| Skewness | 3.3491681 |
| Sum | 741999.8 |
| Variance | 253189.25 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 6.16 | 6 | 0.3% |
| 141.96 | 6 | 0.3% |
| 14.76 | 6 | 0.3% |
| 301.96 | 6 | 0.3% |
| 18.84 | 6 | 0.3% |
| 603.92 | 5 | 0.2% |
| 41.96 | 5 | 0.2% |
| 31.984 | 4 | 0.2% |
| 242.352 | 4 | 0.2% |
| 77.952 | 4 | 0.2% |
| Other values (1626) | 2069 |
| Value | Count | Frequency (%) |
| 1.892 | 1 | |
| 1.988 | 1 | |
| 2.032 | 1 | |
| 2.328 | 2 | |
| 2.784 | 1 | |
| 2.91 | 1 | |
| 2.96 | 2 | |
| 3.312 | 1 | |
| 3.48 | 1 | |
| 3.984 | 2 |
| Value | Count | Frequency (%) |
| 4416.174 | 1 | |
| 4404.9 | 1 | |
| 4297.644 | 1 | |
| 4228.704 | 1 | |
| 4007.84 | 1 | |
| 3785.292 | 1 | |
| 3610.848 | 1 | |
| 3504.9 | 1 | |
| 3406.664 | 1 | |
| 3393.68 | 1 |
Quantity
Real number (ℝ)
| Distinct | 14 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7850071 |
| Minimum | 1 |
|---|---|
| Maximum | 14 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 8 |
| Maximum | 14 |
| Range | 13 |
| Interquartile range (IQR) | 3 |
Descriptive statistics
| Standard deviation | 2.2516203 |
|---|---|
| Coefficient of variation (CV) | 0.59487876 |
| Kurtosis | 2.2214521 |
| Mean | 3.7850071 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.3452701 |
| Sum | 8028 |
| Variance | 5.069794 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3 | 534 | |
| 2 | 503 | |
| 5 | 253 | |
| 4 | 247 | |
| 1 | 193 | 9.1% |
| 6 | 121 | 5.7% |
| 7 | 115 | 5.4% |
| 9 | 58 | 2.7% |
| 8 | 58 | 2.7% |
| 10 | 12 | 0.6% |
| Other values (4) | 27 | 1.3% |
| Value | Count | Frequency (%) |
| 1 | 193 | 9.1% |
| 2 | 503 | |
| 3 | 534 | |
| 4 | 247 | |
| 5 | 253 | |
| 6 | 121 | 5.7% |
| 7 | 115 | 5.4% |
| 8 | 58 | 2.7% |
| 9 | 58 | 2.7% |
| 10 | 12 | 0.6% |
| Value | Count | Frequency (%) |
| 14 | 8 | 0.4% |
| 13 | 5 | 0.2% |
| 12 | 6 | 0.3% |
| 11 | 8 | 0.4% |
| 10 | 12 | 0.6% |
| 9 | 58 | 2.7% |
| 8 | 58 | 2.7% |
| 7 | 115 | |
| 6 | 121 | |
| 5 | 253 |
Discount
Real number (ℝ)
High correlation Zeros
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17392268 |
| Minimum | 0 |
|---|---|
| Maximum | 0.7 |
| Zeros | 836 |
| Zeros (%) | 39.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 16.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.2 |
| Q3 | 0.3 |
| 95-th percentile | 0.6 |
| Maximum | 0.7 |
| Range | 0.7 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.18154728 |
|---|---|
| Coefficient of variation (CV) | 1.0438391 |
| Kurtosis | 0.21947188 |
| Mean | 0.17392268 |
| Median Absolute Deviation (MAD) | 0.2 |
| Skewness | 0.94204855 |
| Sum | 368.89 |
| Variance | 0.032959417 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 836 | |
| 0.2 | 615 | |
| 0.3 | 222 | 10.5% |
| 0.6 | 138 | 6.5% |
| 0.1 | 76 | 3.6% |
| 0.4 | 75 | 3.5% |
| 0.5 | 54 | 2.5% |
| 0.15 | 52 | 2.5% |
| 0.32 | 27 | 1.3% |
| 0.7 | 15 | 0.7% |
| Value | Count | Frequency (%) |
| 0 | 836 | |
| 0.1 | 76 | 3.6% |
| 0.15 | 52 | 2.5% |
| 0.2 | 615 | |
| 0.3 | 222 | 10.5% |
| 0.32 | 27 | 1.3% |
| 0.4 | 75 | 3.5% |
| 0.45 | 11 | 0.5% |
| 0.5 | 54 | 2.5% |
| 0.6 | 138 | 6.5% |
| Value | Count | Frequency (%) |
| 0.7 | 15 | 0.7% |
| 0.6 | 138 | 6.5% |
| 0.5 | 54 | 2.5% |
| 0.45 | 11 | 0.5% |
| 0.4 | 75 | 3.5% |
| 0.32 | 27 | 1.3% |
| 0.3 | 222 | 10.5% |
| 0.2 | 615 | |
| 0.15 | 52 | 2.5% |
| 0.1 | 76 | 3.6% |
Profit
Real number (ℝ)
High correlation Zeros
| Distinct | 1777 |
|---|---|
| Distinct (%) | 83.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.6993271 |
| Minimum | -1862.3124 |
|---|---|
| Maximum | 1013.127 |
| Zeros | 33 |
| Zeros (%) | 1.6% |
| Negative | 714 |
| Negative (%) | 33.7% |
| Memory size | 16.7 KiB |
Quantile statistics
| Minimum | -1862.3124 |
|---|---|
| 5-th percentile | -153.3456 |
| Q1 | -12.849 |
| median | 7.7748 |
| Q3 | 33.7266 |
| 95-th percentile | 190.4298 |
| Maximum | 1013.127 |
| Range | 2875.4394 |
| Interquartile range (IQR) | 46.5756 |
Descriptive statistics
| Standard deviation | 136.04925 |
|---|---|
| Coefficient of variation (CV) | 15.639054 |
| Kurtosis | 37.003383 |
| Mean | 8.6993271 |
| Median Absolute Deviation (MAD) | 22.3512 |
| Skewness | -2.2854556 |
| Sum | 18451.273 |
| Variance | 18509.397 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 33 | 1.6% |
| 10.3936 | 5 | 0.2% |
| 2.9568 | 5 | 0.2% |
| 15.525 | 4 | 0.2% |
| 60.392 | 4 | 0.2% |
| 23.028 | 4 | 0.2% |
| -10.1736 | 4 | 0.2% |
| 4.2804 | 4 | 0.2% |
| 45.294 | 4 | 0.2% |
| 9.8856 | 4 | 0.2% |
| Other values (1767) | 2050 |
| Value | Count | Frequency (%) |
| -1862.3124 | 1 | |
| -1665.0522 | 1 | |
| -1002.7836 | 1 | |
| -968.8833 | 1 | |
| -814.4832 | 1 | |
| -786.744 | 1 | |
| -734.5264 | 1 | |
| -653.2834 | 1 | |
| -630.882 | 1 | |
| -619.596 | 1 |
| Value | Count | Frequency (%) |
| 1013.127 | 1 | |
| 770.352 | 1 | |
| 746.4078 | 1 | |
| 700.98 | 1 | |
| 673.8816 | 1 | |
| 629.01 | 1 | |
| 610.8624 | 1 | |
| 609.7157 | 1 | |
| 585.552 | 1 | |
| 580.5394 | 1 |
Interactions
Correlations
| Discount | Postal Code | Profit | Quantity | Region | Row ID | Sales | Segment | Ship Mode | State | Sub-Category | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount | 1.000 | 0.038 | -0.723 | -0.007 | 0.486 | 0.029 | 0.093 | 0.033 | 0.027 | 0.492 | 0.494 |
| Postal Code | 0.038 | 1.000 | -0.026 | 0.027 | 0.921 | 0.015 | 0.006 | 0.045 | 0.000 | 0.960 | 0.019 |
| Profit | -0.723 | -0.026 | 1.000 | 0.139 | 0.057 | -0.037 | 0.188 | 0.000 | 0.000 | 0.188 | 0.223 |
| Quantity | -0.007 | 0.027 | 0.139 | 1.000 | 0.041 | 0.008 | 0.389 | 0.000 | 0.000 | 0.000 | 0.000 |
| Region | 0.486 | 0.921 | 0.057 | 0.041 | 1.000 | 0.046 | 0.013 | 0.000 | 0.000 | 0.990 | 0.015 |
| Row ID | 0.029 | 0.015 | -0.037 | 0.008 | 0.046 | 1.000 | -0.016 | 0.000 | 0.040 | 0.099 | 0.000 |
| Sales | 0.093 | 0.006 | 0.188 | 0.389 | 0.013 | -0.016 | 1.000 | 0.042 | 0.000 | 0.103 | 0.261 |
| Segment | 0.033 | 0.045 | 0.000 | 0.000 | 0.000 | 0.000 | 0.042 | 1.000 | 0.000 | 0.106 | 0.000 |
| Ship Mode | 0.027 | 0.000 | 0.000 | 0.000 | 0.000 | 0.040 | 0.000 | 0.000 | 1.000 | 0.065 | 0.025 |
| State | 0.492 | 0.960 | 0.188 | 0.000 | 0.990 | 0.099 | 0.103 | 0.106 | 0.065 | 1.000 | 0.000 |
| Sub-Category | 0.494 | 0.019 | 0.223 | 0.000 | 0.015 | 0.000 | 0.261 | 0.000 | 0.025 | 0.000 | 1.000 |
Missing values
Sample
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | CA-2016-152156 | 11/8/2016 | 11/11/2016 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420 | South | FUR-BO-10001798 | Furniture | Bookcases | Bush Somerset Collection Bookcase | 261.9600 | 2 | 0.00 | 41.9136 |
| 1 | 2 | CA-2016-152156 | 11/8/2016 | 11/11/2016 | Second Class | CG-12520 | Claire Gute | Consumer | United States | Henderson | Kentucky | 42420 | South | FUR-CH-10000454 | Furniture | Chairs | Hon Deluxe Fabric Upholstered Stacking Chairs, Rounded Back | 731.9400 | 3 | 0.00 | 219.5820 |
| 2 | 4 | US-2015-108966 | 10/11/2015 | 10/18/2015 | Standard Class | SO-20335 | Sean O'Donnell | Consumer | United States | Fort Lauderdale | Florida | 33311 | South | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 957.5775 | 5 | 0.45 | -383.0310 |
| 3 | 6 | CA-2014-115812 | 6/9/2014 | 6/14/2014 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | FUR-FU-10001487 | Furniture | Furnishings | Eldon Expressions Wood and Plastic Desk Accessories, Cherry Wood | 48.8600 | 7 | 0.00 | 14.1694 |
| 4 | 11 | CA-2014-115812 | 6/9/2014 | 6/14/2014 | Standard Class | BH-11710 | Brosina Hoffman | Consumer | United States | Los Angeles | California | 90032 | West | FUR-TA-10001539 | Furniture | Tables | Chromcraft Rectangular Conference Tables | 1706.1840 | 9 | 0.20 | 85.3092 |
| 5 | 24 | US-2017-156909 | 7/16/2017 | 7/18/2017 | Second Class | SF-20065 | Sandra Flanagan | Consumer | United States | Philadelphia | Pennsylvania | 19140 | East | FUR-CH-10002774 | Furniture | Chairs | Global Deluxe Stacking Chair, Gray | 71.3720 | 2 | 0.30 | -1.0196 |
| 6 | 25 | CA-2015-106320 | 9/25/2015 | 9/30/2015 | Standard Class | EB-13870 | Emily Burns | Consumer | United States | Orem | Utah | 84057 | West | FUR-TA-10000577 | Furniture | Tables | Bretford CR4500 Series Slim Rectangular Table | 1044.6300 | 3 | 0.00 | 240.2649 |
| 7 | 28 | US-2015-150630 | 9/17/2015 | 9/21/2015 | Standard Class | TB-21520 | Tracy Blumstein | Consumer | United States | Philadelphia | Pennsylvania | 19140 | East | FUR-BO-10004834 | Furniture | Bookcases | Riverside Palais Royal Lawyers Bookcase, Royale Cherry Finish | 3083.4300 | 7 | 0.50 | -1665.0522 |
| 8 | 30 | US-2015-150630 | 9/17/2015 | 9/21/2015 | Standard Class | TB-21520 | Tracy Blumstein | Consumer | United States | Philadelphia | Pennsylvania | 19140 | East | FUR-FU-10004848 | Furniture | Furnishings | Howard Miller 13-3/4" Diameter Brushed Chrome Round Wall Clock | 124.2000 | 3 | 0.20 | 15.5250 |
| 9 | 37 | CA-2016-117590 | 12/8/2016 | 12/10/2016 | First Class | GH-14485 | Gene Hale | Corporate | United States | Richardson | Texas | 75080 | Central | FUR-FU-10003664 | Furniture | Furnishings | Electrix Architect's Clamp-On Swing Arm Lamp, Black | 190.9200 | 5 | 0.60 | -147.9630 |
| Row ID | Order ID | Order Date | Ship Date | Ship Mode | Customer ID | Customer Name | Segment | Country | City | State | Postal Code | Region | Product ID | Category | Sub-Category | Product Name | Sales | Quantity | Discount | Profit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2111 | 9932 | CA-2015-104948 | 11/13/2015 | 11/17/2015 | Standard Class | KH-16510 | Keith Herrera | Consumer | United States | San Bernardino | California | 92404 | West | FUR-BO-10004357 | Furniture | Bookcases | O'Sullivan Living Dimensions 3-Shelf Bookcases | 683.3320 | 4 | 0.15 | -40.1960 |
| 2112 | 9938 | CA-2016-164889 | 6/3/2016 | 6/6/2016 | Second Class | CP-12340 | Christine Phan | Corporate | United States | Los Angeles | California | 90049 | West | FUR-TA-10001676 | Furniture | Tables | Hon 61000 Series Interactive Training Tables | 71.0880 | 2 | 0.20 | -1.7772 |
| 2113 | 9939 | CA-2016-169824 | 12/12/2016 | 12/17/2016 | Standard Class | NS-18640 | Noel Staavos | Corporate | United States | New York City | New York | 10009 | East | FUR-FU-10004864 | Furniture | Furnishings | Eldon 500 Class Desk Accessories | 60.3500 | 5 | 0.00 | 19.9155 |
| 2114 | 9948 | CA-2017-121559 | 6/1/2017 | 6/3/2017 | Second Class | HW-14935 | Helen Wasserman | Corporate | United States | Indianapolis | Indiana | 46203 | Central | FUR-CH-10003746 | Furniture | Chairs | Hon 4070 Series Pagoda Round Back Stacking Chairs | 1925.8800 | 6 | 0.00 | 539.2464 |
| 2115 | 9956 | CA-2015-141593 | 12/14/2015 | 12/16/2015 | Second Class | DB-12970 | Darren Budd | Corporate | United States | Los Angeles | California | 90045 | West | FUR-TA-10002622 | Furniture | Tables | Bush Andora Conference Table, Maple/Graphite Gray Finish | 273.5680 | 2 | 0.20 | 10.2588 |
| 2116 | 9963 | CA-2015-168088 | 3/19/2015 | 3/22/2015 | First Class | CM-12655 | Corinna Mitchell | Home Office | United States | Houston | Texas | 77041 | Central | FUR-BO-10004218 | Furniture | Bookcases | Bush Heritage Pine Collection 5-Shelf Bookcase, Albany Pine Finish, *Special Order | 383.4656 | 4 | 0.32 | -67.6704 |
| 2117 | 9965 | CA-2016-146374 | 12/5/2016 | 12/10/2016 | Second Class | HE-14800 | Harold Engle | Corporate | United States | Newark | Delaware | 19711 | East | FUR-FU-10002671 | Furniture | Furnishings | Electrix 20W Halogen Replacement Bulb for Zoom-In Desk Lamp | 13.4000 | 1 | 0.00 | 6.4320 |
| 2118 | 9981 | US-2015-151435 | 9/6/2015 | 9/9/2015 | Second Class | SW-20455 | Shaun Weien | Consumer | United States | Lafayette | Louisiana | 70506 | South | FUR-TA-10001039 | Furniture | Tables | KI Adjustable-Height Table | 85.9800 | 1 | 0.00 | 22.3548 |
| 2119 | 9990 | CA-2014-110422 | 1/21/2014 | 1/23/2014 | Second Class | TB-21400 | Tom Boeckenhauer | Consumer | United States | Miami | Florida | 33180 | South | FUR-FU-10001889 | Furniture | Furnishings | Ultra Door Pull Handle | 25.2480 | 3 | 0.20 | 4.1028 |
| 2120 | 9991 | CA-2017-121258 | 2/26/2017 | 3/3/2017 | Standard Class | DB-13060 | Dave Brooks | Consumer | United States | Costa Mesa | California | 92627 | West | FUR-FU-10000747 | Furniture | Furnishings | Tenex B1-RE Series Chair Mats for Low Pile Carpets | 91.9600 | 2 | 0.00 | 15.6332 |